#!/bin/bash

mysql -uroot -pasdf loan << QUERIES

update loan_credit set status=101 where application_code='2017051010102500101089843096B' and product_id='3002';
update loan_credit set status=101 where application_code='2017051110102500101088946594B' and product_id='3002';
update loan_credit set status=101 where application_code='2017051010102500101089778337B' and product_id='3002';
update loan_credit set status=101 where application_code='2017051010102500101092722037B' and product_id='3002';
update loan_credit set status=101 where application_code='2017051010102500101087810629B' and product_id='3002';
update loan_credit set status=101 where application_code='2017051110102500101093071732B' and product_id='3002';
update loan_credit set status=101 where application_code='2017051010102500101090924802B' and product_id='3002';
update loan_credit set status=101 where application_code='2017051110102500101094070666B' and product_id='3002';
update loan_credit set status=101 where application_code='2017051010102500101092841494B' and product_id='3002';
update loan_credit set status=101 where application_code='2017051010102500101087911705B' and product_id='3002';
update loan_credit set status=101 where application_code='2017051110102500101093958719B' and product_id='3002';
update loan_credit set status=101 where application_code='2017051110102500101090130516B' and product_id='3002';
update loan_credit set status=101 where application_code='2017051110102500101090041991B' and product_id='3002';
update loan_credit set status=101 where application_code='2017051010102500101088839964B' and product_id='3002';
update loan_credit set status=101 where application_code='2017051110102500101089143007B' and product_id='3002';
update loan_credit set status=101 where application_code='2017051010102500101093714892B' and product_id='3002';
update loan_credit set status=101 where application_code='2017051010102500101094839294B' and product_id='3002';
update loan_credit set status=101 where application_code='2017051110102500101091020775B' and product_id='3002';
update loan_credit set status=101 where application_code='2017051110102500101094100704B' and product_id='3002';
update loan_credit set status=101 where application_code='2017051110102500101094139879B' and product_id='3002';
update loan_credit set status=101 where application_code='2017051010102500101089909099B' and product_id='3002';
update loan_credit set status=101 where application_code='2017051010102500101090872942B' and product_id='3002';
update loan_credit set status=101 where application_code='2017051110102500101093073784B' and product_id='3002';
update loan_credit set status=101 where application_code='2017051010102500101087942467B' and product_id='3002';
update loan_credit set status=101 where application_code='2017051010102500101093754553B' and product_id='3002';
update loan_credit set status=101 where application_code='2017051010102500101090640228B' and product_id='3002';
update loan_credit set status=101 where application_code='2017051110102500101089931552B' and product_id='3002';
update loan_credit set status=101 where application_code='2017051110102500101088178713B' and product_id='3002';

QUERIES
